Selecting records using dates

The Month, Day, and Year functions can all be used in examples like the following:

Year ({file.DATE}) < 1999

Selects those records in which the year found in the {file.DATE} field is earlier than 1999.

Year ({file.DATE}) > 1992 and
Year ({file.DATE}) < 1996

Selects those records in which the year found in the {file.DATE} field falls between 1992 and 1996 (1992 and 1996 not included).

Year({file.DATE}) >= 1992 and Year({file.DATE}) <= 1996

Selects those records in which the year found in the {file.DATE} field falls between 1992 and 1996 (1992 and 1996 are included).

Month({file.DATE}) in 1 to 4

Selects those records in which the month found in the {file.DATE} field is one of the first four months of the year (includes January, February, March, and April).

Month({file.DATE}) in [1,4]

Selects those records in which the month found in the {file.DATE} field is the first or fourth month of the year (includes January and April, excludes February and March).



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com